Paste data while maintaining the original formatting
To paste data while maintaining the original formatting, follow the steps below:
1.Select the place where you want to paste the data:
•If the clipboard contains data from a single cell/row/column, select the cell/row/column where you want to paste the data.
•If the clipboard contains a range of cells/rows/columns, select the appropriate size range or select the cell/row/column where you want to paste the contents of the first cell/row/column in the range.
|
The first cell for rows is the leftmost cell, for columns is the top cell, and for ranges is the leftmost top cell. |
•If the clipboard contains an object, select the cell to align the upper left corner of the object to.
2.Run the Paste command in one of the following ways:
•On the Home tab, in the Edit group, click 
Paste.
•When working in macOS, select the Edit > Paste command from the command menu.
•On the Home tab, in the Edit group, click the arrow to the right of the Paste button. In the drop-down list, select Paste.
•Right-click the selected cells or the titles/contents of the selected rows/columns to open the context menu. Select Paste from the context menu.
•Press Ctrl+V or Shift+Insert (Windows, Linux) or 
Cmd+V (macOS).
